home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Chip 2005 March
/
chip-cd_2005_03d.zip
/
03d
/
Narzedzia systemowe
/
dbDeveloper 1.95
/
dbdsetup.exe
/
{app}
/
Templates
/
Oracle
/
Trigger.tl
< prev
next >
Wrap
Text File
|
2004-12-12
|
520b
|
20 lines
CREATE OR REPLACE
TRIGGER #owner#.#name#
/*
* Author:
* Description:
* Created: #date# by dbDeveloper
*/
-- { BEFORE | AFTER }
-- { DELETE | INSERT | UPDATE [OF column [, column] ] }
-- [OR { DELETE | INSERT | UPDATE [OF column [, column] ] }]
-- ON [owner.]table
-- [ [REFERENCING { OLD [AS] } old [NEW [AS] new]
-- | NEW [AS] new [OLD [AS] old] } ]
-- FOR EACH ROW
-- [WHEN (condition)] ]
BEGIN
-- Add PL/SQL statements here
END #name#;